Tabela MedicalProductDefinition

Definicja tabeli MedicalProductDefinition

Name

MedicalProductDefinition

Code

MedicalProductDefinition

Comment

 


Lista kolumn tabeli MedicalProductDefinition

Name

Code

MedicalProductDefinitionID

MedicalProductDefinitionID

Code

Code

Symbol

Symbol

SubstanceGroup

SubstanceGroup

FullName

FullName

ShortName

ShortName

Form

Form

Dose

Dose

Package

Package

ResponsibleCompany

ResponsibleCompany

Quantity

Quantity

Status

Status

UnitMeasure

UnitMeasure

UnitsCount

UnitsCount

UnitMeasureCode

UnitMeasureCode

SubstanceGroupName

SubstanceGroupName

EAN

EAN

DictionaryVersion

DictionaryVersion

ActiveIngredientGroupID

ActiveIngredientGroupID

IsDictEntry

IsDictEntry


Kolumna MedicalProductDefinitionID tabeli MedicalProductDefinition

Definicja kolumny MedicalProductDefinitionID tabeli MedicalProductDefinition

Name

MedicalProductDefinitionID

Code

MedicalProductDefinitionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli MedicalProductDefinition

Definicja kolumny Code tabeli MedicalProductDefinition

Name

Code

Code

Code

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna Symbol tabeli MedicalProductDefinition

Definicja kolumny Symbol tabeli MedicalProductDefinition

Name

Symbol

Code

Symbol

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna SubstanceGroup tabeli MedicalProductDefinition

Definicja kolumny SubstanceGroup tabeli MedicalProductDefinition

Name

SubstanceGroup

Code

SubstanceGroup

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna FullName tabeli MedicalProductDefinition

Definicja kolumny FullName tabeli MedicalProductDefinition

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli MedicalProductDefinition

Definicja kolumny ShortName tabeli MedicalProductDefinition

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna Form tabeli MedicalProductDefinition

Definicja kolumny Form tabeli MedicalProductDefinition

Name

Form

Code

Form

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna Dose tabeli MedicalProductDefinition

Definicja kolumny Dose tabeli MedicalProductDefinition

Name

Dose

Code

Dose

Data Type

VARCHAR2(35)

Mandatory

No

Comment

 


Kolumna Package tabeli MedicalProductDefinition

Definicja kolumny Package tabeli MedicalProductDefinition

Name

Package

Code

Package

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna ResponsibleCompany tabeli MedicalProductDefinition

Definicja kolumny ResponsibleCompany tabeli MedicalProductDefinition

Name

ResponsibleCompany

Code

ResponsibleCompany

Data Type

VARCHAR2(70)

Mandatory

No

Comment

 


Kolumna Quantity tabeli MedicalProductDefinition

Definicja kolumny Quantity tabeli MedicalProductDefinition

Name

Quantity

Code

Quantity

Data Type

NUMBER(10,5)

Mandatory

No

Comment

 


Kolumna Status tabeli MedicalProductDefinition

Definicja kolumny Status tabeli MedicalProductDefinition

Name

Status

Code

Status

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UnitMeasure tabeli MedicalProductDefinition

Definicja kolumny UnitMeasure tabeli MedicalProductDefinition

Name

UnitMeasure

Code

UnitMeasure

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli MedicalProductDefinition

Definicja kolumny UnitsCount tabeli MedicalProductDefinition

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(15,5)

Mandatory

No

Comment

 


Kolumna UnitMeasureCode tabeli MedicalProductDefinition

Definicja kolumny UnitMeasureCode tabeli MedicalProductDefinition

Name

UnitMeasureCode

Code

UnitMeasureCode

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna SubstanceGroupName tabeli MedicalProductDefinition

Definicja kolumny SubstanceGroupName tabeli MedicalProductDefinition

Name

SubstanceGroupName

Code

SubstanceGroupName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna EAN tabeli MedicalProductDefinition

Definicja kolumny EAN tabeli MedicalProductDefinition

Name

EAN

Code

EAN

Data Type

VARCHAR2(14)

Mandatory

No

Comment

kod EAN


Kolumna DictionaryVersion tabeli MedicalProductDefinition

Definicja kolumny DictionaryVersion tabeli MedicalProductDefinition

Name

DictionaryVersion

Code

DictionaryVersion

Data Type

VARCHAR2(10)

Mandatory

No

Comment

wersja slownika


Kolumna ActiveIngredientGroupID tabeli MedicalProductDefinition

Definicja kolumny ActiveIngredientGroupID tabeli MedicalProductDefinition

Name

ActiveIngredientGroupID

Code

ActiveIngredientGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

Grupa substancji czynnej


Kolumna IsDictEntry tabeli MedicalProductDefinition

Definicja kolumny IsDictEntry tabeli MedicalProductDefinition

Name

IsDictEntry

Code

IsDictEntry

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy wpis pochodzi bezposrednio ze slownika PRH?


Lista kluczy tabeli MedicalProductDefinition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MedicalProductDefinition

Definicja klucza Identifier_1 tabeli MedicalProductDefinition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment